USE FEDERATION StateFederation(stateid = 0) WITH RESET, FILTERING=OFF
go
/****** Object:  Table [dbo].[State]    Script Date: 12/28/2011 23:49:10 ******/
INSERT [dbo].[State] ([StateID], [Name]) VALUES (4294967296, N'DC')
INSERT [dbo].[State] ([StateID], [Name]) VALUES (8589934592, N'MD')
/****** Object:  Table [dbo].[County]    Script Date: 12/28/2011 23:49:10 ******/
INSERT [dbo].[County] ([ID], [Name], [StateID]) VALUES (4294967296, N'DCc1', 4294967296)
INSERT [dbo].[County] ([ID], [Name], [StateID]) VALUES (8589934592, N'MDc1', 8589934592)
INSERT [dbo].[County] ([ID], [Name], [StateID]) VALUES (8589934593, N'MDc2', 8589934592)
/****** Object:  Table [dbo].[City]    Script Date: 12/28/2011 23:49:10 ******/
INSERT [dbo].[City] ([ID], [Name], [StateID], [CountyID]) VALUES (4294967296, N'DCc1c1', 4294967296, 4294967296)
INSERT [dbo].[City] ([ID], [Name], [StateID], [CountyID]) VALUES (8589934592, N'MDc1c1', 8589934592, 8589934592)
INSERT [dbo].[City] ([ID], [Name], [StateID], [CountyID]) VALUES (8589934593, N'MDc1c2', 8589934592, 8589934592)
INSERT [dbo].[City] ([ID], [Name], [StateID], [CountyID]) VALUES (8589934594, N'MDc2c1', 8589934592, 8589934593)
INSERT [dbo].[City] ([ID], [Name], [StateID], [CountyID]) VALUES (8589934595, N'MDc2c2', 8589934592, 8589934593)
go

-- ALTER FEDERATION StateFederation SPLIT AT (stateid=8589934592)
